if object_id('TeacherInsert') is not null
	drop proc TeacherInsert
	
go

create proc TeacherInsert
	@Name nvarchar(100)
as
begin
	insert into Teachers (Name) values (@Name)
	select scope_identity();	
end	